Question Bank

MS OFFICE

FILL IN THE BLANKS

1. Page setup can be done using ---------- in ---------- menu ( page setup , file )
2. --------- and ------------- are the two orientations that can be fixed in page set up ( Portrait, Landscape)
3. A file created using Word is saved ----------- facility in file menu ( save)
4. Mistakes can be checked using -------------- facility I Word ( Spelling and Grammar)
5. Space between lines can be changed using ----------- facility in Word ( Line Spacing)
6. Newspaper like formatting can be done using the ----------- facility in format menu ( Column)
7. First letter of a word in paragraph can be separately formatted ------------- facility ( Drop cap)
8. To take a duplicate of a existing file use ------------------ facility in Word ( save as)
9. Paper size facility is available in page setup option in ------------ menu ( File)
10. Saving transfers data from --------------- to ------------- ( Primary, Secondary)
11. Mail Merge facility is used when --------------------- (Multiple copies of save letter to be prepared)
12. While Mail Merging the changing or variable data is stores in document calledЕЕ.. ( Data source document)
13. Field created while Merging is inserted into --------------- finally ( Main document)
14. Mail Merge facility is available in -------------- menu ( Tools)
15. ------------- and --------------- documents are merged to take the final output document ( Main document, Data Source
16. ------------------- document need not be saved after printing the output (output)
17. ------------------ facility in Word can be used to Mailing labels ( Mail Merge)
18. To create a letter --------------- option is used after clicking on create button (Form letters)
19. A Biodata format or an Invoice or Application format can be designed systematically using -------------- ( Table)
20. Inside an existing table a new row can be added using ----------- facility in table menu ( Insert menu)
21. By selecting the ------------------ the heading of a table can be allowed to repeated in the subsequent pages (Heading)
22. Columns and Rows width and height can be adjusted by clicking and dragging on ----------
( Gridlines)
23. To insert a blank line above the table in a new document ---------- and press УEnter key ( Click inside the first cell)Total number of Rows in a Spread sheet is ---------- ( 65536)
24. ------------- number of sheets can be inserted by the user ( 255)
25. Headers and Footers are visible only in (Print Preview)
26. Columns starts with ---------- and ends at ----------- (СAТ, IV)
27. Margins can be set using ---------------- facility in ----------- menu ( Page setup, file)
28. -------------- are not printable objects ( Gridlines)
29. Superscript and subscript facility is available in-------------- tab of Format cells ( Font)
30. Height of a Row and width of a Column can be set using ------------- and ---------- item in Format menu (Row, Column)
31. ---------------- is the default number of sheets in Excel ( 3)
32. Formula alone can be copied from the facility available in ------------- (Paste special)
33. Series of values can be filled in rows/columns using the facility -------------- in edit menu ( fill Ц series)
34. A sheet can be renamed using the --------------- facility (Rename)
35. Sheet background can be inserted using --------------- menu (Format)
36. Sheet can be copied by shortcut using ------------------- ( Ctrl key)
37. All file opened can be found in ---------------- menu ( window)
38. For deletion more than one sheet can be selected by holding --------------( Ctrl key)
39. Each cell has a ------------------ (Cell address)
40. -------------- can be used in generating formulas (Cell Addresses)
41. -------------- helps to substitute Cell Addresses
42. ------------------- formula copies all contents from A1 cell ( = A1)
43. -------------- is the function used for adding cell values ( sum ( ) )
44. Product () helps to ------------- the cell values ( Multiply)
45. Values in the cell A1 to A5 and A10 to A15 can be added with a value 25 as ---------- (= sum (A1:A5,A10:A15,25)
46. Depended values of a formula can be located using ---------------- (Auditing)
47. Conditional evaluations can be done using --------------- function (If)
48. Animations can be both on --------------- and ----------- ( Slides, Text)
49. In Access each row demotes a ----------------------- (Record)
50. In Access = Date() denotes -------------- ( Current date)
51. In Access Rows are technically called as --------------- (Tuples)
52. In Access Columns are called ------------------- ( Attributes)
53. In Access Fields which contain values that can be act as unique identifier is ---------- (Primary key)
54. --------------------- determines the format of data while display in Access ( Format properties)
55. Each Row denotes a -------------- in Access (Record)
56. Pictures can be inserted using --------------- control in Access (Image)
57. Different actions can be easily inserted and activated using ----------- control in Access ( Command button)
58. Features of each from or controls placed can be changed using --------- facility in Access ( Properties)

TRUE AND FALSE

1. A macro can be assigned to a button - True
2. It is not possible to select two non adjacent rages at a time - True
3. One disadvantage of database is that they can be used only by a single user - True
4. For placing the prompt in the first line on the screen the DOS command is CLS - True
5. A report design can be based on the result of a selected query
6. The data contained by the table of database can be used as a data source for mail merging
7. A form is used to make both input and output on a table - True
8. The file extension of an access file is . Xls - False
9. An object such as paint brush picture and Word document can be inserted in a worksheet - True
10. It is possible to save a worksheet in such a way that any user can open it and view it, but only those knowing the password can modify it.- True
11. To create a database, select the view menu - True
12. The cut command moves text to another place and delete it from its original place - True
13. In MS Access forms are used for inputting the data. - True
14. Paint is one of the application in Accessories - True
15. The extension of a template file in MS Word is .doc - False
16. We can work more than one document at the same time Ц False
17. The current date cannot be inserted in the header - False
18. Formulas are copied from one sheet to another using copy paste - False
19. Multiple programs can be executed simultaneously in Windows - False
20. Double clicking a word in a sentence will select the entire sentence - False
21. When a word icon file is opened, it will display document window - True
22. Calculations in MS Word table are done by using formulas - True
23. A Word file is saved with .Dot Extension -False
24. In Ms Word minimum font size is 72 - False
25. Excel print by default with grid lines - False
26. Alt + F3 will close a window - True
27. In Excel maximum number of Work sheet in a book is 156. - False
28. In Word sort option is in window menu - False
29. Header and footer option is in tools menu - False
30. Back ground option is in table menu. - False
31. Word can run only on Dos and Windows Ц False
32. The menu bar is displayed below the title bar
33. Word contains only two tool bars Ц False
34. To open the file menu, we can press УF: - False
35. The line below the tool bar is called the ruler bar Ц True
36. The ruler bar helps you to set and clear tab stop positions Ц True
37. The file, save command and the save button on the tool bars have different effects Ц False
38. To close the word program, we can use the exit button on the standard tool bar Ц False
39. To close the word program select the quit command from the file menu - False
40. The page up key moves the cursor to the beginning of the document Ц False
41. Del and backspace keys have the same function and effect in Word Ц False
42. When the cursor is at the beginning or end of a paragraph and you press the Enter key, word inserts a blank line Ц True
43. To select a line, click the mouse anywhere in the line Ц False
44. To display the paragraph marks on the screen, we can press the paragraph button Ц False
45. The length of a paragraph must be more than one line Ц False
46. To delete the word at the cursor position, you do not need to select it Ц True
47. Word has separate commands to delete the selected sentence and paragraph Ц False
48. To close a document, select the close command from the file menu Ц True
49. To print the current document you can select the print command from the file menu Ц True
50. In Word formula option is in Table menu Ц True
51. The current data cannot be inserted in the Header Ц False
52. Word prints header in the top margin Ц True
53. Without a mouse one cannot work with windows Ц False
54. It is not possible to select two adjacent ranges at a time Ц False
55. Macros that are stored in a macro sheet work with all work sheets Ц False
56. If you double click mouse on a word, it select that word Ц True
57. Bold, Italics and Bold Italics are available for all fonts Ц True
58. Note pad is a text editor Ц True
59. A work sheet contains 200 columns Ц True
60. Save option is I edit menu - False

SHORT QUESTIONS

1. What are the main features which made Windows so popular
2. Explain the following terms in brief:
3. Name the modules in MS Office 97 and name 2 similar suites
4. Explain status bar in Excel
5. How will you prepare a list in MS Access Table
6. What is the difference between selection query and action query
7. Write down the difference and similarities between Word pad and notepad in Windows
8. How will you create a table in Word
9. How will you bind a text with a rectangular box
10. Explain what is If analysis with examples
11. Explain the Tables in MS Word
12. Explain Chart in Excel
13. Explain file allocation Table
14. Explain Data Analysis
15. Explain Action Queries
16. What are the differences between Comment and Footnote
17. What is a compound document
18. What are the different types of graphs
19. Explain Edit text
20. Write down steps to create Index entry
21. What are the steps to delete a foot not
22. What are the steps tom protect a document using save as
23. What is meant by sorting of data
24. What is a folder? How we can make a folder
25. What is meant by spread sheet
26. What is consolidation of Data
27. Write 5 functions in Excel and Explain it
28. What are the steps to take multiple copy of an object
29. Briefly explain about start menu
30. Explain about paragraph settings in Word
31. Hoe to setup a page in MS Word
32. How to Check spelling and grammar mistakes in Word
33. How to insert more than one Header and Footer
34. Ho w to set Heading levels and outline numbers
35. How to create a master document
36. How to mark index entries
37. How to insert a book mark and hoe to use it
38. How to animate a text
39. What is meant by Auditing
40. How to protect a Work book
41. what is meant by Conditional formatting
42. How to applying formulas across sheets/work books
43. How to set boarders for your statement
44. How to create sub forms in Access
45. What is meant by append Query
46. What is meant by advanced filtering
47. Explain about Pivot Table in Excel
48. Explain Scenario in Excel
49. Explain about Goal seek in Excel
50. Explain Data Analysis
51. Explain file allocation Table
52. What is Auto content Wizard
53. How we can animate text in MS Word
54. What is Macro How we can create Macro
55. How we can create reports in an Access file
56. Explain the use of Treasures
57. Explain data validation
58. Difference between Paste and paste special
59. What do you mean by templates
60. How can you print a page in PowerPoint

ESSAYS
1. Explain what is mail merge and how you can Mail Merge a document
2. What are the major features of Windows and Excel
3. Explain important features of excel
4. Explain the features of Microsoft Windows
5. Explain different formatting options available in MS Word
6. Explain the Major features of different MS Office software tools
7. Discuss the steps for creating a presentation in MS PowerPoint
8. What are functions in calculations? Explain with examples
9. What is the use of Word Processor? Explain any 4 menus of a Word Processor
10. How to insert different tools in Access
11. How to create Flow charts in Power Point
12. Explain conditional structures in PowerPoint
13. Explain How to animate a text
14. Explain about the different data types in Access
15. What are the main components of MS Access
16. Name the modules in office 200 and explain it briefly
17. What are the main features which made windows so popular
18. What are the different types of Graph? Write down steps to create a graph
19. Briefly explain about Desktop and Start Menu
20. Explain the techniques for making a PowerPoint show livelier
21. Discuss the steps for creating a presentation in MS PowerPoint
22. Explain the major features of different MS Office software tools
23. What is Query? What are the different types of Queries available in MS Access
24. Distinguish between style and macro
25. What is filtering? How can it be done? Write the steps
26. Explain different formatting options available in MS Word
27. What do you mean by Macro? What are its uses
28. What are functions? What is the significance of functions in calculations? Explain with examples.
29. Explain the different commands available in File menu of Word
30. Explain different options in View menu of Word